Release 10.1A: OpenEdge Data Management:
SQL Reference

DROP VIEW

Deletes the view from the database.

Syntax

DROP VIEW [ owner_name.]view_name ;

owner_name

Specifies the owner of the view.

view_name

Names the view to drop.

Example

DROP VIEW newcustomers ;

Notes

If owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.
When a view is dropped, other views that are dependent on this view are not dropped. The dependent views become invalid.

Authorization

Must have DBA privilege or ownership of the view.

Related statements

CREATE VIEW